SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410104 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410104 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391875,334266,579485,420736,1013788,814417,657932,289928,145929,78360,155281,107751,939080,771933,637842,53044,442460,1040247,855198,779757,463944,605061,1019368,16023,494171,7726,363364,211915,411738,898934,269252,420906,142180,434220,785101,311281,802900,428206,547529,465701,141148,404211,884619,740944,489978,642453,756604,189513,922606,283399,704724,250920,691385,415904,467123,299081,193403,413884,17287,758907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]