SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508830 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508830 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414808,748337,471201,1004819,886670,302385,517550,567772,426299,1046212,724496,733638,412201,991354,392238,778835,123801,166304,40450,646485,418179,33223,895304,829599,822845,799931,1039871,204152,867495,409639,774224,81102,409133,634149,604645,349737,469575,1015123,906551,408591,1020903,15884,826640,383285,1022218,459197,265709,803432,845405,339422,332467,182591,963817,363008,262558,835594,491524,774364,69581,776622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]