SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003457s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035201 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035201 [ RunTime:0.003369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586463,430307,58913,622063,223817,291027,848942,771450,364256,205228,723483,868067,1029366,829682,365185,599708,181362,597526,1038798,254111,995124,644031,310584,559059,177025,870147,793254,611876,234031,41094,712792,487908,702627,689387,63896,496425,388479,393830,692904,810721,850117,822755,621650,588271,626789,628944,830961,54649,362189,41110,825893,96526,466870,741196,401935,162813,635102,206682,3068,1033865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]