SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047060 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047060 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382019,438575,547320,773805,264578,348843,742497,891989,667034,249835,807612,387703,714953,140942,295749,870073,408949,322918,876594,479909,190774,861291,378235,828818,488324,149641,427582,535979,738479,715700,626862,757405,1027622,755737,202891,156030,774876,411278,808264,872257,765386,8504,467521,665973,296282,231995,655570,391701,163254,1040978,621844,595224,92259,957355,139839,87220,743571,909831,97350,1040095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]