SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413842 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413842 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420817,670800,694549,811347,329752,248838,835787,1031115,283791,131345,780163,907963,912605,509016,909122,427300,813430,167277,112817,25859,416337,29960,491356,1020910,490539,1047160,151185,509857,722197,982068,563749,978124,221222,1036843,648836,9399,606921,251242,565620,1035116,210117,1023421,926986,518807,737538,498827,450951,443156,484230,724669,559170,363308,834497,200233,331598,404736,2206,784186,282368,696288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]