SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410787 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410787 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563697,202613,840211,431385,411431,702432,401156,147028,1044094,308259,654493,672162,291294,466785,453058,998022,65699,482165,966554,41581,701205,37987,367317,674615,292712,848926,782294,336231,952004,874371,347264,528874,855441,762118,351876,428784,866408,676462,801624,912101,574734,196061,805243,288695,57600,84442,422760,641129,865293,53804,941087,778949,116897,39960,547210,306303,287821,667943,300157,1048137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]