SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447387 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447387 [ RunTime:0.003064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84223,805920,59144,396936,605466,528861,822059,636508,208725,517145,1039419,998218,660921,160047,352904,96403,314371,949932,131096,224464,211275,25360,398600,785909,411538,180761,277383,1032024,878601,728569,741068,227456,559250,483970,107493,899229,639807,739659,473038,8417,578676,357816,13137,112403,299469,382383,625870,190626,1024037,824948,606528,833980,142611,981913,950842,1029975,443508,224672,869283,519151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447387 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447387 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000720s ]