SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542980 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542980 [ RunTime:0.002310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528070,672580,273405,369379,376043,423758,896639,327155,481101,640227,331589,2553,668402,1036766,152479,790709,136009,835544,945654,504087,205435,405991,317968,785143,721374,467703,992157,265147,805037,613892,565872,124158,318229,127295,172550,391389,252674,443005,328189,993412,780329,1038917,872933,375769,750253,462625,940925,553056,572499,1046293,362147,97389,950485,261793,655969,81881,817528,296888,20377,277832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000389s ]