SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391022 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391022 [ RunTime:0.001413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307437,323094,1018519,173901,873613,1041606,307710,370508,18890,966190,880159,529370,734299,175432,253113,876653,1033041,425009,542539,500902,607745,307641,445192,851837,961667,339091,227939,132700,666286,845894,183240,739633,399932,602835,571124,613360,413049,553477,131467,746522,328081,502059,1023622,722688,306938,119752,756274,1029155,356746,117284,537618,673385,710280,500882,151377,564281,321612,87769,870717,683664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002040s ]