SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346106 LIMIT 1 [ RunTime:0.001498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346106 [ RunTime:0.002821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84511,534138,527234,495186,108548,1011543,719050,54317,687470,75175,542931,360140,12427,152436,154158,650472,175415,621105,919975,307240,40701,932608,811076,415086,273825,737384,701380,664640,366228,253098,697845,945322,536632,476083,1043133,732196,230795,556707,672064,955027,956428,912040,649500,674358,2645,531349,316765,789054,807660,413671,381751,633692,856761,373069,744214,252843,924536,747182,727203,71212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]