SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801653 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801653 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216301,488956,331776,138152,320191,354754,650742,995061,107859,948057,619847,927839,234259,989347,479264,167433,598365,160401,336613,281917,683424,554517,772339,137740,567707,719435,489457,964335,930688,947427,897513,790540,289996,519620,870670,200127,788020,549392,578130,690583,804656,356304,649585,640253,443689,952713,354717,1036792,367438,290754,790438,971523,143232,414081,794236,15181,490199,772351,275537,505488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]