SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558941 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558941 [ RunTime:0.004100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40005,1001372,792840,961012,257682,908504,797758,652295,463819,20037,45147,329566,494328,1019057,667745,457216,991301,1043581,754107,573259,640529,802902,822330,942190,18278,1012786,184890,506556,701919,630083,37514,137089,524908,248569,243099,915663,1019587,493618,251127,643599,152446,186278,209740,59773,651497,4710,66975,463296,988811,472996,160257,755631,203289,847794,966084,993752,280685,1000605,36109,630871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000809s ]