SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004091 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004091 [ RunTime:0.005179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829742,90938,528541,557524,778037,68768,190391,24634,734620,642118,181482,59980,698022,580345,70947,712560,281307,103952,465782,1013729,677424,449848,614988,676092,645250,21338,952061,892922,509121,1026105,69652,559633,1042050,795092,315887,482610,843920,315449,683516,411660,332452,957239,70302,460547,343732,328363,955074,824638,969427,674360,27984,669986,491672,690151,237706,73204,436318,69934,105110,93062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]