SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101052 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101052 [ RunTime:0.003010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412752,838899,977593,546626,3204,326000,901204,263845,277079,842958,770195,527813,552541,406493,873409,245665,141298,265020,1037243,764066,300146,123828,640910,35966,418950,260864,178233,284732,1048869,550173,374103,293005,996921,210075,804733,751813,485041,120964,937408,860328,201955,879234,611170,522803,266686,977749,560018,432903,866131,916939,899625,85064,742844,81850,781469,681129,495970,625855,426648,127018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]