SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 2912 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 2912 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556066,874732,192384,743996,99287,382740,969195,335550,542905,191811,890201,825552,196597,84800,685215,410745,203820,80245,318408,750636,978540,707480,474837,222294,134213,199075,362589,661829,541317,309685,988454,457021,851286,1028166,49450,525188,771240,711786,169198,200945,248041,1033273,105111,45356,320823,1002577,9927,870351,431994,676369,370333,774350,338238,913311,776678,777786,894576,313447,226699,617480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 2912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 2912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]