SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018448 LIMIT 1 [ RunTime:0.002013s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018448 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274227,196223,120231,640365,702980,658850,389171,577676,254597,465662,27273,768450,515463,548752,298888,70245,851852,489597,117264,854986,654656,851326,790190,36377,901631,922666,573682,853076,705528,988855,248961,896394,953263,858125,142871,773347,985611,474456,612225,796766,182370,523457,307754,505844,313598,710244,502980,793846,108947,1017121,312449,925119,138256,305618,175520,747441,558393,890592,865532,90061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.009647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003540s ]