SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 214398 LIMIT 1 [ RunTime:0.000797s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 214398 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296864,235642,437674,237348,15945,402829,162138,5984,447085,855461,1032903,312442,630100,730570,876207,545790,471046,59032,383931,654711,173229,227989,1030542,838196,390025,899574,560998,655313,183508,356128,817290,170768,420480,127987,907726,352371,305249,289808,996775,863494,453921,686590,852912,1041311,322295,200457,443551,384303,612646,250822,670574,907919,145171,625069,518882,115525,280378,73934,626236,929447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 214398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 214398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]