SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 904553 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 904553 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221934,1026696,208991,348028,816540,572210,884731,1010849,364712,778581,240482,130517,487698,960403,794989,832980,557983,1041631,698263,259402,517677,729967,822544,172057,572573,24537,76513,862280,474882,107175,29783,831281,634913,895225,79340,819746,690557,587183,928995,592384,143823,147386,53662,656468,763199,956577,85145,412497,616463,110512,306646,817226,431085,136361,1039024,146190,384427,702203,262304,92849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 904553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 904553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]