SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039722 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039722 [ RunTime:0.002383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534578,384335,683,557761,492646,217987,443498,8890,378173,906943,899635,963843,720887,102948,811745,431872,248570,580322,734231,641563,776189,384476,519075,37742,457693,346663,401582,162591,339712,936578,1033986,902781,909903,558490,278404,980834,14324,947524,514351,858693,487029,205867,579682,168757,797142,459203,856286,459103,509527,728873,869768,114038,622985,1044815,981696,1035513,174344,849336,681484,672091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001073s ]