SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405117 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405117 [ RunTime:0.002495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207043,613056,885143,84996,35156,931387,445559,491577,177287,208935,581997,1031196,578478,781998,120399,175070,660425,849297,1022190,1019526,503135,19468,718767,497290,619856,172407,7045,134460,278246,505221,74242,29864,941557,37652,894009,31545,368210,819815,422525,881121,740045,958722,870029,50287,558622,244717,999165,554591,954899,92528,205747,392664,684922,137219,717828,67735,249205,494510,717633,916076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]