SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45188 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45188 [ RunTime:0.002750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885854,974089,846649,858383,195807,150946,370693,331885,216918,787540,518522,28267,50928,901418,572528,985377,176619,640664,404769,803911,372033,554774,95125,311356,929960,539533,990121,213997,291836,860356,869346,591147,136557,610495,694307,549946,823866,829135,577280,60488,1010723,153664,800052,987315,119845,134706,833984,760860,446682,859808,360798,215454,401688,612837,360812,968250,681367,685942,264592,699036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001896s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]