SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525194 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525194 [ RunTime:0.004043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680642,282008,187811,428467,487077,1040621,834172,202666,617099,876546,282610,120682,758528,509515,649870,678650,164870,1027536,733135,314519,813615,561408,370323,502098,860586,111421,366794,90100,176436,613492,931659,49343,24766,131301,1009152,430065,24542,470502,86885,322392,384374,389387,292377,780676,861746,502210,948985,782448,664767,632916,451441,681959,862903,285756,686133,639283,262194,171734,444254,346434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000751s ]