SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405691 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405691 [ RunTime:0.001379s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156933,437239,954719,541413,689420,140013,427864,225157,242815,852085,521932,72331,327765,286502,135099,935533,425474,325635,397883,277953,725997,649578,103593,67435,737688,241486,547420,932012,944141,31964,105784,343625,294425,960997,509825,367941,994997,273098,1008918,790586,357227,261582,362196,346082,856524,793458,601634,895858,278263,396569,402104,214276,553885,955562,465533,752173,1045983,195617,534168,350460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]