SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287238 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287238 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429852,634372,83589,839891,95372,962325,579726,324201,253924,846196,884147,1025887,168407,270666,469414,680266,22105,361014,687805,988222,268787,870210,1024662,89466,55291,465979,332560,352096,680210,984962,847227,958526,90515,231514,572682,809878,552891,199187,938386,197541,778901,743719,534190,279029,995631,158928,1025878,473525,887520,54840,132268,223786,140138,518162,982650,471662,409052,73997,410584,740934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000938s ]