SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509894 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509894 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035757,724126,767036,950238,870878,851838,265653,433906,721229,539184,987663,140943,225752,833200,323798,159755,538318,374992,707845,478908,288830,673242,797580,221537,648549,213415,991482,184891,145210,61330,876671,364348,824442,669545,818701,389692,646123,807655,581294,559780,775100,1025524,991079,669427,1029030,33255,939190,28782,158431,18287,665944,158524,138559,854790,492259,284917,523682,414736,734763,99821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]