SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520875 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520875 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924280,175757,474832,585463,470483,53568,470934,673730,331320,1002015,53303,305096,857500,912932,514152,547640,742229,632690,573347,872229,706975,407225,572846,245862,746032,156300,302702,773311,1013244,755686,393395,1008355,967260,304312,410500,488200,540154,22781,743648,43812,538185,688161,913142,325906,1044904,615075,729762,609902,594392,985654,130816,221754,756044,548708,756843,716508,681865,575555,1032538,853370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]