SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505207 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505207 [ RunTime:0.003527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895537,888832,199219,172302,29430,246275,483871,251323,523031,1039551,995809,737298,777802,408057,584767,341066,657412,934069,283079,417732,187198,280752,583132,92387,932203,142214,735105,105385,750981,100747,64560,218375,631003,640296,562806,214147,613013,388055,682239,862084,365582,659267,198970,949815,72746,817201,672436,970010,881418,830852,568077,96012,928004,84720,1021968,514896,728711,171561,194556,893475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]