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` = 538092 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538092 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586664,297416,819024,382820,552283,417102,355787,155822,138589,974964,221598,947730,301650,272454,487929,1006141,12072,592564,472273,555436,39149,837876,588859,768849,128442,834352,273689,68032,63919,162580,28479,818040,1009726,853095,114288,314664,252630,772382,551928,981911,389436,269245,72866,832766,629517,967680,726008,305830,837315,987389,29653,42300,246972,536867,923029,21231,49361,285332,421358,700431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]