SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046588 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046588 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608649,848611,1037968,735707,270117,451336,1001534,501318,203139,286395,127989,706816,807299,676257,831672,555135,430618,1045744,498798,945413,800008,854786,448924,838155,373238,891870,907942,646627,512814,605134,1000771,692106,567733,793445,96902,271408,193396,761217,449377,995816,110131,505631,920251,188510,614913,237804,601976,709586,58946,777473,1028184,630362,795644,690307,350531,350172,101469,230131,619745,990042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]