SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002476s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200990 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200990 [ RunTime:0.005309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602899,581135,768918,67123,108946,817209,192179,635727,743114,900048,619832,633169,223639,568937,61186,890189,887817,786681,745070,65634,642107,395484,379662,145304,373201,162059,550028,161590,432116,961010,969128,566151,1035983,855746,797641,961660,986507,175029,726170,101432,118859,812485,492375,1029609,589480,231358,960279,350307,598305,327669,961559,83686,99853,53490,631636,50163,452714,985886,697532,77491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]