SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511034 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511034 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408505,380235,100381,264797,304031,386038,118959,311431,782031,102124,652624,497039,546541,742213,110705,347052,727695,196014,30116,914715,800251,868993,894723,401989,692893,748561,7754,50124,32988,342007,50993,141375,218768,686557,737348,446846,138793,948493,597584,98062,411710,929862,612749,41121,86772,590514,503984,991065,767297,918558,102909,29407,982832,792412,343801,516002,313918,249934,475433,199305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]