SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030870 LIMIT 1 [ RunTime:0.002813s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030870 [ RunTime:0.002663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047561,918535,248441,926139,457867,928828,843959,220520,339897,402295,279027,649245,336508,769975,871737,951252,1001380,969612,649432,543020,872584,396600,503683,328086,3147,957740,15890,525617,762394,26399,513768,765382,198799,251023,1038970,594811,649586,406434,354277,685703,795923,578110,54211,217037,456737,459748,1042425,442528,994057,686554,444930,254061,236065,268459,497403,654022,680570,27245,389686,755678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001771s ]