SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001474s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567396 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567396 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014391,96823,1015798,430860,136201,379697,958703,170554,1004739,503695,646116,275717,604994,131417,390863,734860,431403,1042532,994066,110022,926820,672044,1001511,635139,641172,860829,557091,646582,891649,112279,12921,188536,1018240,135075,572873,269351,937210,484227,547093,249568,423348,297708,998137,942029,454067,183634,502011,197635,794865,183590,478385,243613,167649,230201,289693,801226,771063,332486,765105,803913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]