SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046220 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046220 [ RunTime:0.003908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477881,128872,703911,602250,237086,438241,556602,782106,239364,452290,764863,1035810,551865,759152,649863,359234,53950,902782,874741,816934,1001158,338865,764077,663811,636652,146872,335940,257756,921181,396528,580396,499301,244401,863756,112850,536480,492487,302812,770849,747602,401617,301230,621764,131228,778883,587476,764013,206859,407983,709346,310435,793284,603155,838446,173185,747487,73625,755061,820069,721426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001109s ]