SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340071 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340071 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36415,72012,120832,30325,710366,836225,857807,999404,926485,623091,585509,724445,719766,448640,903631,260031,441759,1020839,969216,187986,120971,484694,877687,575038,357042,991272,310781,839562,130276,707930,797782,370696,331291,184532,121083,916947,131251,638778,302413,311333,648297,251883,772,225429,776591,787127,791682,752501,62524,177349,86369,451476,168452,1043739,499387,267479,9785,272678,1044597,205370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002112s ]