SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10679 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10679 [ RunTime:0.001476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4673,1004935,71537,434672,499544,734264,743388,342902,553117,301657,201868,848288,390385,610538,202659,476240,881201,148014,412828,947658,472732,487058,26031,783959,152003,235603,307301,879048,56762,426898,4663,438034,165905,590371,905121,245399,613199,758721,224006,492824,488500,651756,618798,284553,871909,824577,811252,840394,918848,384639,539606,333741,316387,648800,424035,714902,920353,488036,934129,132653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000813s ]