SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300004 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300004 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216122,140607,752714,929106,707275,964835,304052,570,349034,633883,722471,451046,139374,902828,234914,276604,549546,497994,178429,710060,323406,868121,610094,395338,861156,231605,1001516,47153,862038,203272,76091,826481,993407,1002025,852841,80605,954547,602499,798144,865863,317433,478524,715468,253737,736682,781947,761689,698839,266752,464950,793600,301891,214347,498102,261389,400537,137883,25801,417535,612761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]