SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293315 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293315 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036867,238492,194112,1018716,51357,938719,973229,170005,645114,371264,370830,659571,887213,289709,160248,27040,8248,169932,753682,175460,700166,1006760,151701,556713,7204,862034,586490,157107,1010073,980472,565228,350505,230788,738367,228040,803388,669124,429964,750173,411136,733777,16492,700585,156903,241609,811477,114681,544194,487596,35456,943579,42137,994566,677052,390825,254438,447231,671159,504600,359905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]