SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50199 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50199 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336152,186503,894518,357391,86031,358230,807392,80623,622431,721033,356108,246417,145774,325226,382297,802293,439565,499987,957272,312788,637697,32321,60495,338904,334942,712659,380102,511108,879122,628444,279645,445274,990953,140397,973982,1025997,46469,497351,90198,812810,514332,391610,904833,331341,998071,230092,432850,522316,900808,579176,544662,261017,808842,845434,847830,119536,31346,14193,994082,367835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]