SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420596 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420596 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902027,641817,568343,925338,853289,206545,300777,752180,279712,224380,448061,739265,136814,37042,179605,46059,45139,650004,308286,558763,607799,631468,915670,333441,206461,661195,65590,205791,357976,925377,97678,967266,555964,854145,569495,130718,574545,252005,351727,114968,495944,507164,834995,522228,445145,632933,805869,915891,997865,350166,966079,333320,11866,686186,612567,629183,320269,467375,466265,142971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]