SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 680319 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 680319 [ RunTime:0.002417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256696,503969,82734,109550,112727,549963,651219,440791,906487,167484,522594,169432,494588,875723,472323,1019651,271981,496909,492701,823401,1045045,401058,894096,715840,440105,268174,375487,606012,965602,77562,471406,851424,948485,233641,476076,948141,638961,832528,721662,855352,1045403,185676,688381,962985,426662,22029,1040851,844543,334243,259456,70261,991911,933110,487878,369675,780565,67072,628389,535423,823944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 680319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 680319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]