SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463909 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463909 [ RunTime:0.001453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585120,722875,221635,64041,5624,853341,1815,476068,170160,802758,520236,517415,381570,829057,309816,826469,362403,356966,243079,1026196,17996,809034,645525,529953,186737,297878,897438,819360,874825,98444,6230,686696,288548,567317,556234,156023,382109,993175,92946,989057,587485,339411,162120,293754,51318,850507,941415,851510,481509,116708,154823,477313,681683,423222,312917,79902,1006042,843052,1009375,669226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]