SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002474s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336150 LIMIT 1 [ RunTime:0.001062s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336150 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110910,964017,32527,199617,307325,614637,786439,86677,1035360,29942,938757,1002366,628509,905727,672167,184421,506720,174000,377737,776371,842262,399246,56561,141797,827775,321914,777329,467490,158702,640836,919956,343831,531841,450779,709813,995830,727409,532423,353878,87933,928023,975042,699172,154565,427536,220295,614627,971047,485882,312942,912362,498799,167723,661699,507081,623120,256165,1001120,91898,1020075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]