SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154151 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154151 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512824,662142,839748,697945,534700,134682,507872,349176,370097,659377,780361,283225,353518,584467,805205,127075,812390,789793,460546,650675,401635,112910,622340,999265,660735,425907,419082,666214,346079,488245,546999,1020988,540164,373147,585698,1014059,242581,599309,209786,159667,259903,659813,152394,372789,920373,345098,538772,344518,633038,981643,304227,737416,1028512,712312,810704,579505,267647,787230,874449,299295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]