SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 182004 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 182004 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645412,186208,573453,852472,339734,852192,714314,549022,336529,345846,289610,409384,192087,972528,163608,38864,552536,197266,112751,426538,816944,416930,142492,790950,27941,882881,103886,803405,30519,201960,859421,367488,385570,671275,820533,29844,881007,408533,531323,90539,470698,338185,377442,14043,649154,556392,998728,324116,175890,612094,575761,190992,16592,923177,301449,523408,469684,142617,816904,331254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 182004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 182004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]