SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014304 LIMIT 1 [ RunTime:0.001700s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014304 [ RunTime:0.002239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69274,170821,714346,504328,275593,484003,872379,186516,1041971,681149,933845,429363,723113,387400,923387,902931,902486,620297,733545,529210,520778,915601,212201,794071,783854,496490,349914,530728,133314,864528,243701,568682,57794,990904,533156,955860,794254,234868,449118,389196,590463,463093,203809,151315,535392,903752,401600,116089,458390,289144,526740,207643,924135,745303,1010634,225611,877185,308740,837082,103585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]