SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001790s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404618 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404618 [ RunTime:0.002236s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191390,497458,105676,471693,873751,757981,678920,953247,251408,798483,228220,137774,282171,970985,1008768,762423,754995,577980,195849,1004670,425278,179308,683165,1014206,819485,702149,261617,84562,478112,65041,963088,915980,864439,209591,345813,142663,11570,609622,718515,955825,473120,285011,745373,3961,780405,482236,360309,660271,393290,847520,829733,454605,27155,1041820,822492,934874,866970,293894,657981,992339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001555s ]