SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338791 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338791 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200723,769671,117892,710733,910972,798832,887674,786836,253071,186757,444357,118532,771201,225133,197649,826291,753863,222027,328250,967641,85849,1021219,253149,756957,386966,237027,2419,210555,537450,954682,620858,525079,262244,316158,211538,986969,591141,699072,384424,569685,237705,845036,726320,362613,179548,35199,328168,520812,315934,270497,22235,500447,925642,713116,970360,225550,751670,333952,635375,959578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]