SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417216 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417216 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804760,501368,816048,938570,649592,622654,444071,703,552040,65051,612560,26741,498219,797432,647386,100146,178230,1040872,596340,450358,238926,614343,205182,661515,963511,838402,361771,781849,328518,583702,236639,960800,499181,456534,127304,479422,757657,299854,169887,957383,894439,352859,606816,803397,980118,723800,92089,261097,414083,384151,430947,763633,128636,479289,53689,687061,62338,545156,981382,328119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]