SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038675 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038675 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736586,175091,685008,958383,465695,416913,346927,486009,594961,544401,608865,972996,65397,778439,323851,52497,715217,75485,761613,378368,773489,1046364,133550,441506,1007544,267958,190233,645737,1009707,831004,720716,1000819,72047,41961,820849,775776,319375,27117,832832,687308,284981,546866,891070,872971,53321,598476,593718,431545,853071,38021,435372,626376,491760,215792,17778,842178,809595,286727,398432,564459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038675 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038675 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]