SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38008 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38008 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201971,759275,1015933,549955,432496,748337,29947,15940,916413,1044847,332320,708444,578902,283179,836037,683092,822688,150335,619033,347769,725571,447568,782547,142085,325869,525462,718854,547201,1042217,330948,718634,111595,441450,179116,710395,740339,261146,964391,587214,1047895,295900,587475,747572,468556,801284,175013,900478,3153,733104,623765,405368,964529,458864,497397,278187,1034780,335068,279065,1001133,122675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]