SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449018 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449018 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172278,308697,765557,381765,47944,850173,111335,1045163,659406,68957,924105,551425,453598,526343,79069,1027843,313308,156687,864052,723455,404056,975862,619485,948068,318810,109081,640283,731775,262279,165184,528349,924384,463820,177222,389544,69604,412703,16811,256432,650626,118873,41744,642383,376010,885047,387120,840399,644961,1018502,922012,366060,1034154,168167,445659,1025922,290633,1002130,1027255,939105,811990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001693s ]