SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395019 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395019 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141253,897039,190284,753328,1034981,740617,210321,651283,14831,358841,576544,5413,95121,837440,232721,769090,657599,736030,440143,1041703,386929,718115,826437,693885,721862,75674,1004074,771296,733271,257564,471147,458600,486642,377966,573684,398494,692638,601892,517680,686343,985433,819605,282315,489875,563568,169908,666298,66452,76549,33482,683528,132216,293400,381131,985583,216194,105790,928989,219088,785880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]