SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044287 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044287 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701519,292823,220825,1007748,519794,23372,669037,61574,957798,697129,770816,393394,652008,175021,757371,338519,99088,103970,330272,100161,502616,377389,363334,1001014,627876,260161,481487,947701,648187,665953,540077,836389,615175,727627,756175,664104,8180,5757,421346,330335,457068,705487,784252,77372,520332,685771,630413,335892,910587,698745,1029581,109468,751157,761289,939565,847721,835783,942954,888696,106833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044287 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044287 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]