SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40916 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40916 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398734,849343,54617,887633,622341,265091,19424,688278,816892,549954,432950,346214,324719,598184,267389,214691,802339,537399,244166,612856,246517,19403,64612,288819,570637,28240,1047831,386675,744837,750153,304335,995279,136540,1009584,709136,242094,394424,963174,385960,162784,478777,1010825,903047,255569,129420,918776,8873,42174,74809,518481,833871,452906,375131,51085,1047296,223514,676035,836243,290626,731827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]