SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520928 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520928 [ RunTime:0.002031s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158071,755756,986969,232574,110367,354423,103231,181778,189208,416125,442237,643358,868997,604664,1032223,530419,256152,226909,705904,351380,997522,221202,430124,6576,971552,610164,142749,142514,167558,726652,108981,985744,714975,724591,569450,627529,311803,110068,788666,723904,464954,431155,3256,610203,410330,951543,203852,493789,935643,765411,132913,587081,296711,721695,559486,108811,598340,281482,11648,661598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]