SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466033 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466033 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439993,910449,502832,67321,146703,851130,696771,878772,538557,82420,456595,278469,959481,954928,974960,389722,410804,220774,747111,679657,408399,364964,825389,597932,376400,96241,473155,62483,431324,651617,266303,402879,115651,177980,805372,503973,833511,668090,263888,431911,93341,164283,696178,1005333,360376,379919,791221,353943,567937,523544,646937,922827,393330,52780,755169,240254,869435,886084,47649,786580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000869s ]