SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002307 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002307 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890041,212093,259478,399371,524394,62305,700115,554596,580995,800317,109806,345587,41524,208774,741274,368261,916089,219461,482352,782841,20662,274136,595174,480456,1003340,684506,387682,396904,109200,482559,321781,193000,262127,1278,560478,180269,526531,159651,686479,676004,914092,80175,1018537,669256,1034012,361230,201951,743706,924525,857264,550047,456799,374814,849768,825282,533141,212836,645432,267363,469588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]