SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046450 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046450 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119709,165401,391213,951971,628942,936091,804918,83421,102926,344869,258584,499013,18275,53722,190367,911684,382505,231627,622017,524412,202775,796301,597615,176095,618400,1013788,713368,386651,852497,759544,563670,816446,379313,369416,890784,381572,806760,455357,885995,140063,865722,589456,668417,661025,292271,525110,36448,56212,422049,798684,928663,57475,920048,705654,609584,252465,59712,526751,367334,852192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]