SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110648 LIMIT 1 [ RunTime:0.000675s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110648 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558105,296062,983252,725483,1028897,877247,880102,464588,828751,931215,324612,438600,420895,676053,520007,872646,720092,651625,307111,1014129,598607,777690,63851,806073,697219,30670,709837,475219,387925,348570,628066,620289,768194,753050,466445,438075,291034,722323,131310,426495,107669,169883,169310,469230,690385,118637,5757,1004668,208880,994624,646542,954407,91448,982992,286525,605554,116731,505452,778114,861030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]