SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568451 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568451 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587384,784868,47315,913479,648020,742490,72389,406513,22171,1012516,779875,518140,615686,570478,858250,339152,714917,745279,62373,820573,100718,884361,713901,549348,832082,660685,120539,166775,635642,1009197,538428,316777,317200,656775,829443,802128,315091,245094,444985,446098,502432,524971,1020847,850684,800186,68407,544913,773564,575032,746600,890957,880926,254954,731945,16375,1040040,20070,707081,395221,1003257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]