SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106253 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106253 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262182,15270,554733,407649,438943,843716,92559,707496,615462,56160,920525,634287,736332,1011699,419468,221538,403685,544477,838011,127277,103892,738392,975316,973001,862814,818576,589306,353310,101911,706930,1048322,93246,259663,697045,752620,188587,931020,484986,94532,802479,166822,398371,398654,254536,739167,82239,1033881,1012971,309617,513190,1002584,985143,274717,57909,400447,461563,756271,811925,525833,783862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]