SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517909 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517909 [ RunTime:0.002161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914910,970898,690459,234680,284579,762062,1012483,825085,110231,864829,627991,586866,277913,238872,32597,910016,797038,726386,704445,735661,204239,950676,668987,191608,383153,371986,67304,976523,9652,775283,559110,223594,2985,1007886,888982,246253,600654,604118,375756,131171,190793,992554,1006064,194545,467514,770164,998292,208680,919255,605641,462420,26833,224854,975191,451648,477645,677842,726726,371186,1035891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001692s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]