SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001800s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244826 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244826 [ RunTime:0.002446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216822,93719,190806,646163,65339,767305,520322,197789,213023,751681,879650,185379,972805,260718,720544,547647,135314,780749,150123,159831,457589,20879,703846,27486,927772,233700,1019973,1025818,1039364,760389,766655,613482,412720,926289,902966,140480,899781,978027,866792,478455,36159,715992,567960,688160,99726,1028969,35031,699178,56820,476507,709749,479106,559232,862824,591485,346907,970008,571798,940313,684364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001439s ]