SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 582178 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 582178 [ RunTime:0.002506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882804,320132,446798,375352,378489,93474,843062,448111,871390,1020163,193092,822285,970933,824104,67596,309732,1003621,863934,552716,311257,587870,809068,349739,23021,315320,525041,634866,274649,934257,755691,992301,614448,328472,210396,318230,86354,943738,101271,318227,1029756,995112,218204,673258,110868,1008373,890680,397183,426828,716988,174902,1026817,750386,612796,689179,933327,574065,850960,873930,154418,129309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 582178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 582178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]