SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029644 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029644 [ RunTime:0.002752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152435,518147,292274,189418,606428,864035,1045718,852104,566603,1031743,898556,589532,690725,549583,956968,702382,341448,699401,1020943,979004,4997,566709,357940,400519,754026,157735,754374,205352,526972,315736,113835,758414,438502,98647,651107,299417,821458,179609,738336,735002,540711,397380,338443,135506,171973,445733,394731,686593,620046,259362,497336,852095,422743,592420,393301,44631,338773,588960,19982,842217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000361s ]