SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493908 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493908 [ RunTime:0.002461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016639,828010,524762,855386,452216,1033613,101722,125750,638794,173048,26702,626818,684331,698288,612110,9424,751329,198860,667532,299648,148887,1012426,306344,95346,945164,627060,806607,676067,250215,6436,150097,479569,45728,394674,909105,514800,606696,378371,205635,147007,579642,702964,222982,288581,481306,495979,1047220,710893,450832,381767,728224,837117,732842,628046,929854,189368,69302,76528,36860,918868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001708s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000944s ]